Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# Understanding the DBMS_AWM Procedures

The procedures in the `DBMS_AWM` package support methods on several types of logical entities. These entities are described in Table 1-1.

See Also: Chapter 26, "DBMS_AWM"

Table 1-1 Logical Entities in the DBMS_AWM Package

Entity | Description
--- | ---
Dimension | A dimension in the OLAP Catalog and its corresponding dimension in an analytic workspace.
Cube | A cube in the OLAP Catalog and its corresponding cube in an analytic workspace.
Dimension Load Specification | Instructions for populating an analytic workspace dimension from the dimension tables of an OLAP Catalog dimension.
Cube Load Specification | Instructions for populating an analytic workspace cube from the fact table of an OLAP Catalog cube.
Cube Aggregation Specification | Instructions for creating summary data in an analytic workspace.
Cube Composite Specification | Instructions for ordering dimensions and storing sparse data in an analytic workspace.

## Methods on Dimensions

The methods you can perform on a dimension are described in Table 1-2.

Table 1-2 Methods on Dimensions in DBMS_AWM

Method | Description | Procedure
--- | --- | ---
Create | Create the metadata in an analytic workspace for a dimension defined in the OLAP Catalog. | CREATE_AWDIMENSION Procedure
Refresh | Use a dimension load specification to populate an analytic workspace dimension from the dimension tables of an OLAP Catalog dimension. | REFRESH_AWDIMENSION Procedure
Enable for non-OLAP clients | Create a script to enable relational access to a dimension in an analytic workspace. | CREATE_AWDIMENSION_ACCESS Procedure
| Create a script to disable relational access to a dimension in an analytic workspace. | DELETE_AWDIMENSION_ACCESS Procedure
| Create and run a script to enable relational access to a dimension in an analytic workspace | CREATE_AWDIMENSION_ACCESS_FULL Procedure
| Create and run a script to disable relational access to a dimension in an analytic workspace. | DELETE_AWDIMENSION_ACCESS_ALL Procedure
| Refresh the workspace metadata that supports user-defined view names for a dimension in an analytic workspace. | REFRESH_AWDIMENSION_VIEW_NAME Procedure
| Specify names for the relational views of a dimension in an analytic workspace. | SET_AWDIMENSION_VIEW_NAME Procedure

## Methods on Cubes

The methods you can perform on a cube are described in Table 1-3.

Table 1-3 Methods on Cubes in DBMS_AWM

Method | Description | Procedure
--- | --- | ---
Create | Create containers in an analytic workspace for a cube defined in the OLAP Catalog. | CREATE_AWCUBE Procedure
Refresh | Use a cube load specification to populate the measures of an analytic workspace cube from the fact table of an OLAP Catalog cube. | REFRESH_AWCUBE Procedure
Aggregate | Use an aggregation specification to aggregate the cube in the analytic workspace. | AGGREGATE_AWCUBE Procedure
Enable for non-OLAP clients | Create a script to enable relational access to a cube in an analytic workspace. | CREATE_AWCUBE_ACCESS Procedure
| Create a script to disable relational access to a cube in an analytic workspace | DELETE_AWCUBE_ACCESS Procedure
| Create and run a script to enable relational access to a cube in an analytic workspace. | CREATE_AWCUBE_ACCESS_FULL Procedure
| Create and run a script to disable relational access to a cube in an analytic workspace. | DELETE_AWCUBE_ACCESS_ALL Procedure
| Refresh the workspace metadata that supports user-defined view names for a cube in an analytic workspace. | REFRESH_AWCUBE_VIEW_NAME Procedure
| Specify names for the relational views of a cube in an analytic workspace. | SET_AWCUBE_VIEW_NAME Procedure

## Methods on Dimension Load Specifications

The methods you can perform on a dimension load specification are described in Table 1-4.

Table 1-4 Methods on Dimension Load Specifications in DBMS_AWM

Method | Description | Procedure
--- | --- | ---
Create/Delete | Create or delete a dimension load specification. | CREATE_AWDIMLOAD_SPEC Procedure DELETE_AWDIMLOAD_SPEC Procedure
Reset information | Change various components of a dimension load specification. | SET_AWDIMLOAD_SPEC_DIMENSION Procedure SET_AWDIMLOAD_SPEC_LOADTYPE Procedure SET_AWDIMLOAD_SPEC_NAME Procedure SET_AWDIMLOAD_SPEC_PARAMETER Procedure
Add/Delete filter | Add or remove a filter from a dimension load specification. | ADD_AWDIMLOAD_SPEC_FILTER Procedure DELETE_AWDIMLOAD_SPEC_FILTER Procedure

## Methods on Cube Load Specifications

The methods you can perform on a cube load specification are described in Table 1-5.

Table 1-5 Methods on Cube Load Specifications in DBMS_AWM

Method | Description | Procedure
--- | --- | ---
Create/Delete | Create or delete a cube load specification. | CREATE_AWCUBELOAD_SPEC Procedure DELETE_AWCUBELOAD_SPEC Procedure
Reset information | Change various components of a cube load specification. | SET_AWCUBELOAD_SPEC_CUBE Procedure SET_AWCUBELOAD_SPEC_LOADTYPE Procedure SET_AWCUBELOAD_SPEC_NAME Procedure SET_AWCUBELOAD_SPEC_PARAMETER Procedure
Add/Delete filter | Add or remove a filter from a cube load specification. | ADD_AWCUBELOAD_SPEC_FILTER Procedure DELETE_AWCUBELOAD_SPEC_FILTER Procedure
Add/Delete composite specification | Add or remove a composite specification from a cube load specification. | ADD_AWCUBELOAD_SPEC_COMP Procedure DELETE_AWCUBELOAD_SPEC_COMP Procedure

## Methods on Aggregation Specifications

The methods you can perform on an aggregation specification are described in Table 1-6.

Table 1-6 Methods on Aggregation Specifications in DBMS_AWM

Method | Description | Procedure
--- | --- | ---
Create/Delete | Create or delete an aggregation specification. | CREATE_AWCUBEAGG_SPEC Procedure DELETE_AWCUBEAGG_SPEC_MEASURE Procedure
Set operator | Set the aggregation operator for a dimension. | SET_AWCUBEAGG_SPEC_AGGOP Procedure
Add/Delete levels | Add or remove levels from an aggregation specification. | ADD_AWCUBEAGG_SPEC_LEVEL Procedure DELETE_AWCUBEAGG_SPEC_LEVEL Procedure
Add/Delete measures | Add or remove measures from an aggregation specification. | ADD_AWCUBEAGG_SPEC_MEASURE Procedure DELETE_AWCUBEAGG_SPEC_MEASURE Procedure

## Methods on Composite Specifications

The methods you can perform on a composite specification are described in Table 1-7.

Table 1-7 Methods on Composite Specifications in DBMS_AWM

Method | Description | Procedure
--- | --- | ---
Create/Delete | Create or delete a composite specification. | CREATE_AWCOMP_SPEC Procedure DELETE_AWCOMP_SPEC Procedure
Reset information | Change the name of the composite specification or associate it with a different cube. | SET_AWCOMP_SPEC_CUBE Procedure SET_AWCOMP_SPEC_NAME Procedure
Add/Delete members | Add or remove members from the specification. Members can be dimensions or composites. | ADD_AWCOMP_SPEC_MEMBER Procedure DELETE_AWCOMP_SPEC_MEMBER Procedure
Reset member information | Change information about members of the specification. | SET_AWCOMP_SPEC_MEMBER_NAME Procedure SET_AWCOMP_SPEC_MEMBER_POS Procedure SET_AWCOMP_SPEC_MEMBER_SEG Procedure
Add composite members | Add members to a composite in the specification. | ADD_AWCOMP_SPEC_COMP_MEMBER Procedure